
package me.zhengjie.repository;

import me.zhengjie.domain.AppWorkCoverPoint;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

/**
* @website https://el-admin.vip
* @author IQW
* @date 2022-07-18
**/
public interface AppWorkCoverPointRepository extends JpaRepository<AppWorkCoverPoint, Integer>, JpaSpecificationExecutor<AppWorkCoverPoint> {

    @Query(value = "SELECT count(1) FROM app_work_cover_point  WHERE cate_id = ?1 and area_id = ?2", nativeQuery = true)
    int selSonNum(Integer id,Integer areaId);
}